﻿-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[UPD_Movie]
	-- Add the parameters for the stored procedure here
	@MovieId AS INT,
	@Name AS VARCHAR(50),
	@Type AS VARCHAR(50),
	@ViewedDate AS VARCHAR(50),
	@Score AS VARCHAR(5)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
UPDATE [Movies]
   SET [Name] = @Name
      ,[Type] = @Type
      ,[ViewedDate] = @ViewedDate
      ,[Score] = @Score
 WHERE MovieId = @MovieId

END